General Settings for MySQL

The following instruction guides you through the process of creating a new connection for server. To successfully establish a new connection to local/remote MySQL - no matter via SSL, SSH or HTTP, set the connection properties in the corresponding boxes: Connection name, Host name, Port number, User name, and Password etc.

By default, MySQL gives "root" as username and leave the password field blank.

Connection Name
A friendly name to best describe your connection.

Host Name/IP Address
A host name where the database is situated or the IP address of the server.

Port
A TCP/IP port for connecting to the database server.

User Name
User name for connecting to the database server.

Password
Password for connecting to the server.

You can connect to your MySQL Server remotely however for security reasons native remote direct connections to the MySQL server are disabled. Therefore, you cannot use Navicat Premium or other similar MySQL admin applications running on your computer to connect to the remote server directly unless the User Privileges has been configured.

If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol SSH / HTTP is another solution.

See also:
Advanced Settings

Related topics:
SSL, SSH, HTTP